﻿CREATE TABLE [dbo].[UMLHardware_Tbl] (
    [UMLHardwareID]            INT            IDENTITY (1, 1) NOT NULL,
    [UMLHardwareFamilyID]      INT            NULL,
    [UMLHardwareTypeID]        INT            NULL,
    [Reference]                INT            NULL,
    [Description]              NVARCHAR (255) NULL,
    [Unit]                     NVARCHAR (255) NULL,
    [Price]                    FLOAT          NULL,
    [UMLHardwareSuppliersDKID] INT            NULL,
    [ESReference]              NVARCHAR (50)  NULL,
    [PartCode]                 INT            NULL,
    [UMLFlag]                  BIT            NOT NULL
);

